SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetStudentInfoByStudNo] ( @fdStudNo VARCHAR(50) )
AS 
    SELECT  fdStudNo,
            fdStudPwd,
            fdStudName,
            fdStudSchool,
            fdStudCollege,
            fdStudSpec,
            fdLongevity,
            fdStudMethod,
            fdSex,
            fdTrain,
            fdStudYearInt,
            fdStudYearOut,
            fdStudIDCard,
            fdNation,
            fdPolitics,
            fdPlace,
            fdStudTrainUnit,
            fdStudPhone,
            fdStudHomeTel
    FROM    dbo.FS_Student
    WHERE   fdStudNo = @fdStudNo

GO
